Executive Summary 3






ISSUES THAT OCCURRED DURING THE PROJECT


1. Unpivoting & Pivoting the Source Excel files 


2. Converting the Quarter from 'NQYYYY' to Date format 'MM/DD/YYYY'


https://www.sqlshack.com/ssis-script-component-vs-derived-column/